Database Administrator

Location-Remote

Build Mongo dB on AWS with Light Sail servers and implemented Replication & Sharding to handle very large data sets and also involved in code writing.
Designed and developed new Environments for SQL Server and implemented Disaster recovery solutions for the databases using Always On.
Migrated SQL 2008/2016/2017 to SQL 2022 and built Geo-cluster (providing HA and disaster
Recovery solution) and configure always on, replication in sql environment.
Configuring high availability strategies database like mirroring, clustering, and Setting up a database for replication, log shipping, and Database mirroring and monitoring the setup & Creating SSRS reports
Scheduled Backups of databases and recovered them periodically to verify the integrity of Backups.
Migrated SQL databases to the different data centers and the Azure environment.
Build always on infrastructure and clustering environment.
Building and Managing geo-cluster, Active-Active, Active Passive Clusters
Administrating Mongo db and building environment for it.
Administrating MYSQL databases, replication, and optimizing sql queries on the AWS environment.
Build managed instances on the Azure platform.
Working closely with business users to understand the client's requirements and develop ETL packages as per their requirements like BOFA, US bank, Huntington, and many more.
Working on migrating on-premise ETL packages to ADF in Azure cloud, and developing new ETL packages
Developed several database structures, complex SQL queries, writing stored procedures, Views, Triggers and
User-defined functions.
Identifying Slow Running queries T-SQL & analyze and optimize them
Create and manage reports using the SSRS tool.
Create database programming objects using T-SQL, implement error handling, create and manage stored procedures, functions, and views, and optimize queries and stored procedures.
Developed a highly secure environment using SQL symmetric keys
Manage database integrity statistics and monitor SQL Server instances and database activity, queries, and indexes. Develop a backup strategy, restore databases, and configure encryption, data access, permissions, and auditing.